Search results for "dist:SQLite-VirtualTable-Pivot pivot table"
SQLite::VirtualTable::Pivot - use SQLite's virtual tables to represent pivot tables.
A pivot table is a table in which the distinct row values of a column in one table are used as the names of the columns in another table. Here's an example: Given this table : Student Subject Grade ------- ------- ----- Joe Reading A Joe Writing B Jo...
BDUGGAN/SQLite-VirtualTable-Pivot-0.02 - 12 Nov 2009 02:13:53 UTC
SQLite::VirtualTable::Pivot::Cursor - a cursor for a pivot table query
Objects in this class represent cursors for queries on pivot tables. They maintatin a statement handle corresponding to an unpivotted query on the base table. The pivotting operation is done one row at a time, as data is returned; i.e. we order by th...
BDUGGAN/SQLite-VirtualTable-Pivot-0.02 - 12 Nov 2009 02:13:53 UTC